Selecting a sorting option in the sort row determines how the records will be sorted. If more than one field contains a sorting option, Access will sort the records using the sorting option from the first field to the last field going from left to right.